<html>
	<head>
		<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
	</head>
	<body>
		<table border="1" width="1024">
			<tr>
				<th>id</th>
				<th>ชื่อ</th>
				<th>นามสกุล</th>
				<th>หมายเลขโทรศัพท์</th>
				<th>email</th>
			</tr>
<?php
    include '../connectdb.php';
    $q = "select * from customer order by customer_id";
    $res = mysqli_query($link, $q);
    while ($row = mysqli_fetch_array($res)){ 
?>
			<tr>
				<td align="right"><?php echo $row['customer_id'] ?>&nbsp;</td>
				<td><?php echo $row['customer_fname'] ?></td>
				<td><?php echo $row['customer_lname'] ?></td>
				<td><?php echo $row['phone_number'] ?></td>
				<td><?php echo $row['email'] ?></td>
			</tr>
<?php
	}
?>
		</table>
	</body>
</html>